<?php
/* wwwschool project

Copyright (C) 2009  Phillip Aldridge
Email : info@imi21.com
Web site http://www.imi21.com

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

/**
 *  File : updateCourse.php
 *  called only via ajax 
 *  
 *  requires POST  op, id
 */  

checkSession();
if ($session->userType() > 2) // admin and hadhasmaster
{
  die('Wrong user rights');
  exit;
}
$date=date("Y-m-d H:i:s");

$db=new WS3_Database();

$id = $db->makeSafeInt( $_POST['id'] );
$name = $db->makeSafeString( $_POST['name'] );
$description = $db->makeSafeString( $_POST['description'] );

$q="SELECT `id` FROM `theme` WHERE 1 AND `id`= '$id' LIMIT 1";
  
if ($db->query($q) && $db->nextRecord() )
{ 
  
  $db2=new WS3_Database();
  $q="UPDATE `theme` SET
  `date_modified`='$date',
  `name`='$name',
  `description`='$description'
  WHERE  `id`='$id' LIMIT 1";

  if ($db2->query($q)){
   if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"update Theme ok id");
  }else{
    if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"update Theme failed id");
  }

}else
{
    if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"Theme not found id");
}

include 'listThemes.php';
?>